<!--#include file="lib/utf-8.asp"-->
<!--#include file="lib/connopen.asp"-->
<!--#include file="lib/asp-common-lib.asp"-->
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CC的办公系统</title>
<!--#include file="lib/plugins.asp"-->
<style type="text/css">
	.ui-datepicker table {
		border: 0;
	}
</style>
<script type="text/javascript">
	$(function() {
	});
</script>
<!--#include file="lib/js-google-analytics.asp"-->
</head>

<body>
<!--#include file="lib/header.asp"-->
<!--#include file="lib/nav.asp"-->
<div id="main">
<!--#include file="lib/col1.asp"-->
<!--#include file="lib/col2.asp"-->
	<div id="col3" role="main">
		<div id="col3_content" class="clearfix">
		
		<%
			xls_id=request("xls_id")
			tele_num=request("tele_num")
			sum_all=0
			if tele_num<>"" then
				sql = "select * from fee where fee_xls="&xls_id&" and fee_yhhm='"&tele_num&"'"
			else
				sql = "select * from fee where fee_xls="&xls_id
			end if
			Set rs = Server.CreateObject("ADODB.Recordset")
			'response.write(sql)
			'response.end
			rs.Open sql,conn,1,1
		%>
			<table class="full">
				<thead>
					<tr>
						<th>序号</th>
		<%
				for i=2 to rs.fields.count-1
		%>
						<th><%=d.item(rs.fields(i).name)%></th>
		<%
				next	
		%>
						</tr>
				</thead>
				<tbody>

		<%
				do while not rs.eof
		%>
					<tr>
						<td><%=rs.AbsolutePosition%></td>
		<%
					for i=2 to rs.fields.count-1
		%>
						<td>
						<%
							if i=rs.fields.count-1 then sum_all=sum_all+rs.fields(i).value
							response.write(rs.fields(i).value)
						%></td>
		<%
					next
		%>
					</tr>
		<%
					rs.movenext
				loop
		%>
				</tbody>
				<tfoot>
					<tr>
						<th></th>
						<th>合计</th>
		<%
					for i=3 to rs.fields.count-2
		%>
						<th></th>
		<%
					next
		%>
						<th><%=sum_all%></th>
		<%			

				rs.close
				set rs=nothing
		%>
					</tr>
				</tfoot>
			</table>		
		</div>
	</div>
</div>
<!--#include file="lib/footer.asp"-->
</body>
</html>
<!--#include file="lib/connclose.asp"-->

